package cn.gson.crm.model.mapper;

import cn.gson.crm.model.pojos.Customer;
import cn.gson.crm.model.pojos.MoneyBackPlan;
import cn.gson.crm.model.pojos.Order;
import cn.gson.crm.model.pojos.OrderDetails;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface MoneyBackPlanMapper {
    //查询当前登录人下所有回款计划
    public List<MoneyBackPlan> selectmoney(Integer m);
    //查询当前人下所有客户
    public List<Customer> selectcustomer(Integer yg);
    //根据客户id查询没有被退换并且状态是发货的的订单号
    public List<Order> selectorder(Integer cid);
    //根据时间查询回款计划
    public List<MoneyBackPlan> selecttiem(@Param("m") Integer m,@Param("statr") String statr,@Param("endtime") String endtime);
    //回款计划多条件查询
    public List<MoneyBackPlan> selectwhere(@Param("m")Integer m,@Param("where") String where);
    //根据id查询订单详情
    public List<OrderDetails> selectoid(Integer oid);
    //根据订单id查询此计划回款
    public List<MoneyBackPlan> selecthui(Integer oid);


}
